#ifndef BIZQUERYHELPER_H
#define BIZQUERYHELPER_H
#include <QVariantMap>
#include <QList>
#include "dbhelper.h"
#include "QDate"

class bizQueryHelper
{
public:
    bizQueryHelper();
    //收入统计报表
    static QList<QVariantMap> GetIncomeRptGroupByType(dbhelper db, QString filter);
    //支出统计报表
    static QList<QVariantMap> GetPaymentRptGroupByType(dbhelper db,QString filter);
    //收入报表
    static QList<QVariantMap> GetIncomeRpt(dbhelper db,QString filter);
    //支出报表
    static QList<QVariantMap> GetPaymentRpt(dbhelper db,QString filter);
    //具体过滤条件
    //支持时间段内筛选数据，比如2010/06/02至2010/08/03,以下类似
    static QList<QVariantMap> GetIncomeRptGroupByType(dbhelper db,QDate fromDate,QDate toDate,int UserId);
    static QList<QVariantMap> GetPaymentRptGroupByType(dbhelper db,QDate fromDate,QDate toDate,int UserId);
    static QList<QVariantMap> GetIncomeRpt(dbhelper db,QDate fromDate,QDate toDate,int UserId);
    static QList<QVariantMap> GetPaymentRpt(dbhelper db,QDate fromDate,QDate toDate,int UserId);
    static QList<QVariantMap> GetdayPaymentRpt(dbhelper db,QDate d,int UserId);

};

#endif // BIZQUERYHELPER_H
